SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512071 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512071 [ RunTime:0.002884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509163,297969,979665,165592,190474,983042,539324,1004320,705795,172809,90546,926215,252180,172100,626568,244712,781945,10587,460941,110003,620859,997693,972001,198546,659899,668386,869218,288619,351003,75476,105259,87269,62671,163035,228240,305164,772504,264873,775793,1024240,976485,398737,819335,67965,627316,802346,848248,747414,364012,44995,38016,898332,2612,562312,737814,28403,755965,768838,475351,20459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]