SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36384 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36384 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253446,278164,2450,27849,910068,909029,127819,1036771,506680,383214,592767,377282,1023119,285116,517044,200074,14686,678563,409096,443245,990250,489707,517796,52168,638559,751781,406780,522370,1004847,805497,692374,229536,901279,930429,634123,476146,74075,319733,943294,244615,905290,1004863,376601,495144,996893,210220,865116,214613,399949,954473,240349,987589,149607,154408,432057,810345,854296,422145,389782,119038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]