SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106693 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106693 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481953,20016,85801,271755,881072,983591,789186,836983,4436,715328,619145,114970,546913,359619,422897,971539,374398,253265,450140,450676,1030140,402093,788247,395461,1006758,290332,567837,115305,276953,813458,605433,275240,172105,827643,530985,984210,1038694,450919,912276,855433,782845,644449,282860,469903,154829,197267,59084,217439,516403,329298,827410,176893,812715,976734,575096,803761,681689,487084,803371,974039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]