SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505476 LIMIT 1 [ RunTime:0.001807s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505476 [ RunTime:0.002856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776734,130067,884022,752327,966977,778176,761620,115572,569175,319536,340474,380881,419094,860380,837779,596624,752855,336130,216080,760377,48779,325935,419677,490140,994431,59880,155929,77849,281303,525348,708249,349334,111896,315773,751960,174829,280721,625028,798801,1011007,84562,930449,935356,832304,610288,118727,246353,982191,914915,675899,219359,473280,555539,118476,46951,160015,448576,404784,489166,114775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001803s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001270s ]