SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501271 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501271 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535420,38618,881690,423645,625471,732640,680665,472814,942880,924061,9179,995364,100876,1016906,511151,879140,189334,658287,621134,277401,807768,604191,844835,763000,963108,820924,97288,710910,259011,141635,782830,77365,264487,71137,483194,283124,587845,772288,652297,863529,948759,95242,293631,691058,203606,465128,571332,64154,859457,177916,951977,762481,667069,1018174,940349,394845,422802,242294,629036,879388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]