SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002400 LIMIT 1 [ RunTime:0.000656s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002400 [ RunTime:0.002893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470592,190345,96714,79347,382338,418443,831730,82246,456182,680140,623430,508585,397545,617769,319458,477914,46162,1021360,350056,61031,940454,794390,841222,234039,859380,744372,443291,690291,857620,684652,247950,515689,931437,287557,21600,343195,721998,59002,245369,980838,966921,583471,178857,866316,16116,441048,994032,313201,68979,824657,732864,277993,272782,694200,690295,520447,418762,820288,732389,531584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]