SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002703s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391893 LIMIT 1 [ RunTime:0.001401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391893 [ RunTime:0.003347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585390,488116,761118,463402,906830,323372,770694,521670,377787,402697,214166,950984,693862,781695,481908,732931,785024,870726,859413,67720,677427,937140,896226,159778,54206,365718,564380,855139,762328,89774,543606,856565,352201,776480,745522,1029147,4177,76339,564388,907158,988865,679798,649637,675414,154798,917912,432478,944420,510092,970722,840836,453684,38550,766616,313456,804027,222778,905088,448720,782144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]