SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544422 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544422 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998745,210979,811263,366213,105929,281418,550599,624573,420625,1040824,189667,772553,1033197,734968,909828,365113,1007602,1022669,90845,284584,460891,804549,276244,459344,465023,745386,683266,309885,130971,713569,364218,122204,172078,757899,400523,553812,633784,296607,426739,462924,288785,911990,438310,540924,295611,42822,365023,237253,918996,485307,28490,131671,276038,467365,431961,438280,392982,692066,634593,852965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]