SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20610 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20610 [ RunTime:0.003441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54262,1003833,48371,269270,356566,196372,1354,759672,92557,1033591,790187,763789,650191,578563,404045,656030,1043236,857994,574356,483842,55564,774595,48194,639734,820716,382645,698937,507561,263081,915771,964025,870730,39397,300238,669671,799186,1190,819936,315806,474950,696543,88822,1022166,1004538,585664,696253,572736,26966,719074,719648,281791,757324,93942,578010,390816,146486,727046,1008695,951598,453068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]