SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515845 LIMIT 1 [ RunTime:0.001043s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515845 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418151,608072,34365,398447,808647,817171,311934,688455,675958,287711,133871,370868,1033099,604852,129370,322901,463063,656210,273911,1032377,950349,724915,423342,34748,77972,22697,790579,464655,395438,517892,1008935,476315,179299,886319,962945,1037857,636999,110037,316489,357667,103367,449897,162366,385344,767344,661145,478568,447879,881607,617833,589531,950211,409692,653464,963433,638722,620330,702252,824751,268965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.041247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002236s ]