SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001565s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557246 LIMIT 1 [ RunTime:0.000717s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557246 [ RunTime:0.001300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678028,382225,761723,462824,696766,581709,73558,118899,988172,275146,878143,681147,985745,938515,599025,679894,299719,122980,351778,836040,691274,338358,927283,651303,287644,793917,692797,468366,865803,707483,314197,594211,267776,77460,885426,586903,574550,194234,544745,136405,317273,1013971,703424,758696,140434,952318,37166,287380,341087,168827,119724,753672,1046310,483659,559363,293765,350299,658020,473625,483696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]