SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 611012 LIMIT 1 [ RunTime:0.001076s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 611012 [ RunTime:0.006380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132703,497871,580691,748027,947328,846201,921243,794150,872307,269230,493139,461908,240365,79788,587429,384274,27244,86440,1030572,733712,534895,349833,84334,704983,201390,175455,562076,420099,867705,18471,905330,820696,985582,995274,224521,246584,349800,693046,829155,664177,614144,413639,320385,328781,546139,15074,898832,408661,538575,248213,752542,906240,267664,760302,698441,657103,248978,336389,170562,347081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 611012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 611012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]