SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55708 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55708 [ RunTime:0.002245s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021170,196710,1026818,1038010,578439,837035,324670,284178,951536,647706,98854,242647,270650,296531,82026,151518,9827,324893,290012,662269,567594,923189,975988,500751,151962,690941,857438,499424,419179,379668,1039195,355384,388319,933703,764893,786373,845617,706916,467197,604782,796665,692039,1039220,606004,921643,454237,779452,388450,164685,264401,87684,787824,792450,176328,876201,784682,629554,1007812,850812,237652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]