SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481513 LIMIT 1 [ RunTime:0.001409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481513 [ RunTime:0.004736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670078,1008373,355913,604445,461352,438726,267930,931634,98842,33153,277596,835437,816717,242524,797917,642424,386720,52120,744795,781688,1009624,854764,524720,32376,1041908,381963,690491,297554,171081,761679,279828,301195,168248,320222,530190,693161,204917,325548,292940,190531,1016597,349246,91407,345632,37266,479137,688254,130639,578712,277446,207647,337924,533703,118917,434760,288446,657909,937600,961075,559971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002008s ]