SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40981 LIMIT 1 [ RunTime:0.003486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40981 [ RunTime:0.003860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834925,76757,974091,728461,157886,2215,934743,105864,81733,269637,2618,340274,880872,937513,760150,714965,664665,1025165,875707,781587,1047030,816423,435812,988145,33121,539288,499551,231426,533117,946273,1037711,462173,27340,562417,549294,594310,800076,573700,288018,212576,104902,423393,481895,467218,782697,204088,395222,883173,973577,691372,940726,430448,740112,83731,408391,344013,967749,926262,34606,150559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]