SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460916 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460916 [ RunTime:0.002434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133957,1001310,275982,911947,562439,218468,59367,710765,916005,212690,192109,705265,950233,774675,737204,896137,818653,666704,573046,339594,645981,812841,122976,408269,193540,731932,560739,651439,5723,612180,308983,832981,301919,201256,534096,428734,339458,352147,375791,418693,919985,283562,46395,79533,240735,199625,869293,112406,947247,11685,532326,1018972,606,138073,1010299,275413,1011916,1021745,355310,351607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]