SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004609 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004609 [ RunTime:0.001457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119292,376193,295332,480569,552438,663512,811044,427211,301753,406111,100126,390913,121593,221137,999485,845538,490168,218666,605055,398583,243787,268121,24791,841120,827038,610754,740971,362060,809872,130155,972471,652820,539990,738102,666100,830506,596864,367495,138633,537782,351578,7896,425526,749279,734904,1027360,320633,112814,119142,721564,683645,509784,112950,844549,966984,84476,143131,747639,322755,918859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]