SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49190 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49190 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425678,507397,487061,178907,136088,684869,944007,846599,229397,171757,106994,385632,193265,164837,1030869,13179,168528,584505,759763,18760,843404,679761,316523,474289,470263,185073,400330,801709,480480,521919,467717,37820,954907,725929,627731,203562,485794,406143,815697,133221,579405,460147,1036612,725422,96997,1002019,339448,353093,803084,472602,329154,562165,417229,108234,928506,21391,625648,680938,1048722,886666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]