SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405132 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405132 [ RunTime:0.003482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519096,397624,410303,710066,893191,688373,550544,353440,683718,991583,259906,975500,695988,154137,513248,752611,593636,228511,34354,443757,384916,246385,33326,346555,458099,1035134,619660,1007937,731591,674423,482707,302915,412958,751495,380740,611060,969911,484188,737640,1006663,38920,814492,846930,120792,45827,730924,1003433,1034594,106126,615589,716107,592275,970870,188114,113287,699076,1040917,304970,1018370,447527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405132 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405132 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]