SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001577s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541098 LIMIT 1 [ RunTime:0.000623s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541098 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764397,362184,1009312,908265,408959,287552,935587,642984,597262,316665,169126,59605,1045432,432838,626936,242771,763896,685462,153172,430517,14561,603929,1045301,98716,12481,223682,424547,92252,1019658,84532,267655,515591,900093,979714,127276,495545,349026,874312,447010,819427,55370,543604,286081,91750,857690,38265,622366,220100,689906,744873,164621,925357,325828,253373,871522,961628,423713,521708,593770,151172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]