SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578580 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578580 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465934,970415,966381,188397,190245,446811,595351,530037,317913,824155,59541,275719,909611,592388,299764,11101,319315,210156,508616,51611,296991,303468,445524,667668,541678,747101,11589,820285,206868,269025,1020982,497222,204408,945705,215644,600963,197164,714020,334426,949673,974180,348758,18956,249091,745833,525845,972385,293146,95890,803012,768813,71222,219568,189286,30183,686685,7847,919171,676767,999713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]