SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 668140 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 668140 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229295,440796,242003,989649,334747,29601,441758,603654,540785,55609,822193,241836,334697,310052,180131,133774,1036570,719613,701638,22719,877318,147083,97265,1022541,342309,605908,326532,517367,502228,632435,43022,627805,507860,186818,1044950,1033140,371684,662719,593273,683016,201007,682733,874459,244798,849668,232745,245705,908090,787407,767120,576808,992843,940797,1014890,238280,312312,593310,549375,1007746,712610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 668140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 668140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]