SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806911 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806911 [ RunTime:0.006432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124480,691195,1033753,188975,496037,931898,236806,835452,734668,476556,310776,444274,1023844,926968,633831,62721,946657,414341,635671,172008,71076,1036057,210334,282913,828378,347483,965264,661530,736319,269571,916623,951366,1168,535148,217842,582823,723163,209883,66543,371951,563497,90261,50321,993753,263737,576595,437373,27209,394011,581469,368473,677131,459497,428560,380790,972328,370752,948953,427889,376822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]