SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103048 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103048 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468166,528642,863084,232063,234265,752415,908899,88677,414339,116697,264922,202737,439057,41162,280646,318500,784316,1042550,508011,243210,217018,406390,383988,19070,734424,980442,579012,1021693,126075,775293,575537,369599,740681,797310,603799,16531,400649,581252,820218,488751,554976,829147,986212,873995,149585,595963,537163,382625,845598,725135,211455,749204,1015785,217485,409205,40781,31019,565929,570074,23565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]