SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450653 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450653 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94312,898148,964013,918568,602558,403854,554135,651369,794023,395776,671649,677358,501526,468991,56652,665526,880556,16322,501077,306972,843456,723876,698295,383986,124938,934789,852233,176465,85187,656882,369593,453838,322720,258384,127397,555563,363572,23269,524209,562025,273854,993443,290808,603676,1009748,784759,1009370,844413,169212,870974,712781,424635,787971,571500,557915,636337,827270,212755,908981,234546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000377s ]