SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001730s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414918 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414918 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353582,838673,152801,348398,422542,181112,861395,447349,104470,1024957,420668,506315,5337,91074,985194,917984,144966,568268,222666,478466,264792,932091,369688,200350,792877,836726,989544,28038,533359,899374,500182,743940,275848,724052,759114,412012,335499,536471,64996,147207,322453,418974,997272,834603,75141,458695,295236,309766,354107,710556,27485,788339,133234,1025569,321329,700274,948881,925406,133627,400874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]