SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404421 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404421 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503472,800961,75522,439320,556157,920350,648899,957772,118658,1044761,724085,866605,142349,713954,645065,551688,282733,549870,740105,551485,910575,211283,763911,289845,896579,544305,1026968,880527,684351,671278,465809,795763,687833,419086,3541,863497,644823,987769,118154,979997,993276,759237,176324,546362,235115,490656,217355,608194,217968,173261,621075,164705,866918,57313,603197,675645,1047428,21329,133071,279206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]