SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538617 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538617 [ RunTime:0.002571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827142,843243,19718,1036234,882430,138079,940246,207068,448101,446278,907990,295993,762492,57684,792980,178762,626972,188216,322686,441732,967343,820131,892904,652388,134843,304853,962900,469676,291533,340492,463749,116794,180889,491915,479200,40384,1036141,692232,819389,865750,581334,993459,1028732,840647,573358,978766,1022871,508707,446095,565339,479439,708541,1001715,8610,910384,697682,365716,406327,820455,310584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001012s ]