SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030493 LIMIT 1 [ RunTime:0.001255s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030493 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001641,808481,349249,937037,326506,760555,632217,584177,760212,1019393,717056,640521,959549,474905,367040,845871,985404,878345,645599,705201,623246,814485,1020501,393568,132153,331025,57870,99424,72333,336556,266074,796798,1030713,401545,749352,192217,459113,412534,357787,476533,83875,452685,205927,379173,262523,58495,569403,930546,505954,926950,909574,246470,38459,671496,22912,823801,98353,145511,401011,616956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001473s ]