SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501343 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501343 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405955,900211,1007016,859365,321939,202349,913664,583365,1002470,108309,26223,475542,121001,662128,236600,933084,36364,374631,661777,62676,946448,37842,167155,619861,1004044,245819,894080,673544,653085,702074,327741,753744,684425,862867,303609,919710,704570,760905,814053,222583,247436,509115,340122,575139,968999,152715,187224,659060,672426,77181,842819,21854,576983,695918,126047,540893,758910,77331,186017,116553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]