SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364083 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364083 [ RunTime:0.004385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871167,227029,554042,5623,526286,509310,901181,133014,784528,808400,746808,444811,417882,53465,259043,117206,412732,505233,360011,274020,715732,217642,194032,328244,763955,525092,81413,59279,426931,393442,328048,104659,644485,720053,829142,200472,495182,42177,770099,921300,305196,592681,738729,514372,755261,352902,224313,477916,745877,761754,687610,557923,624472,1025569,27150,169912,38323,247477,529981,630788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]