SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 374213 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 374213 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239422,1042651,609115,731165,599090,564252,1011023,742430,620551,1003234,881722,80711,819060,829470,934875,257854,493683,389652,627,933700,798877,453509,230109,1047657,194146,159140,967908,213319,322656,935688,354671,924212,703119,894506,795853,907625,1036684,669752,374988,833479,359008,395003,933614,441150,949746,369596,850480,399046,700602,656666,767132,300590,810908,630159,497281,578553,658553,270776,737447,748180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 374213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 374213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]