SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504386 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504386 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315570,944494,558704,753847,751303,46469,262057,184564,487594,907438,929177,1046245,666925,906785,185225,1047313,588368,485956,818698,608291,185757,814154,302730,500244,614893,381360,911836,908825,749369,755477,972686,1029438,554839,704636,958624,919650,865092,988054,516294,44233,484067,985589,878365,156361,60922,652142,108766,581494,347490,988476,430214,801728,585234,714276,332951,1043980,491853,573865,414752,1001046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504386 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504386 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]