SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45605 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45605 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410999,1012751,112891,454209,169693,604260,799943,186239,396083,421500,586134,130931,787383,290661,112176,857627,935364,590672,32319,988908,159141,591009,110698,67826,617200,986702,81527,846008,761702,512702,34153,517347,351276,784798,146781,756944,531943,1016979,438675,486949,574989,872172,582429,819053,357687,335489,302243,424148,65293,918493,330792,692006,739835,898829,930897,133720,978862,700413,616059,968489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]