SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401474 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401474 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828050,96898,70274,478263,826940,57412,524718,314100,856242,417745,834505,307215,232889,520392,83268,113865,308092,678841,647181,782919,455690,887110,349548,140966,298787,6141,624851,249586,850737,851945,299597,248902,693615,941471,868066,386099,229252,839605,292691,318403,193299,915968,383522,298146,415825,550301,129978,282547,988936,677434,414570,115473,122102,37086,3930,518946,733890,154999,1024369,457958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]