SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381628 LIMIT 1 [ RunTime:0.002160s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381628 [ RunTime:0.003525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511852,155923,75758,451020,1035669,937142,440243,222420,92591,850420,678377,505988,1037873,780330,363425,320881,933345,54744,323615,772998,795676,463584,64478,597,405589,16865,46236,473324,802930,844616,890287,991065,765272,50070,8810,86995,983576,922631,763473,249547,69291,147595,377026,721403,14469,380624,359888,6848,395039,263175,452972,732542,323260,311704,954126,610151,176468,582472,582496,871948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000880s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]