SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 625543 LIMIT 1 [ RunTime:0.001172s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 625543 [ RunTime:0.003723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395128,84238,739667,487852,1025166,197776,1024052,665261,489335,537701,311109,852757,918403,551519,3023,560955,580075,16927,100929,836202,804731,140309,185710,471907,295962,427953,879260,61886,422484,158733,173696,940832,236211,407998,494543,871865,403544,231177,529455,372770,108173,1015568,66115,728400,628860,571659,284208,362273,334120,93732,283146,539358,102873,360858,632878,8464,672112,938866,17177,435470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 625543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 625543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001302s ]