SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312318 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312318 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801921,263071,881705,977213,1047533,124104,879119,86620,878045,514770,579289,35896,864237,582545,741973,438483,371930,183155,1011240,117699,233319,832757,277650,580690,570499,11788,382350,519775,724000,725332,358925,416345,535656,388152,558360,1045009,790201,514259,39400,455266,927061,150947,578204,21730,206001,803521,937558,251756,6016,988130,1019330,91937,333873,532167,249732,149216,969973,935135,392519,220783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]