SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002799s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029101 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029101 [ RunTime:0.002084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840247,204030,977757,751025,193441,838400,548060,653027,637707,212982,517414,774876,626448,326224,364179,886205,298862,538052,88057,743120,840774,661838,273382,45065,329562,293337,581763,46692,12482,499459,593679,787655,249186,665483,441309,365611,71770,54999,495884,586405,727959,996481,588864,63950,910503,912390,424567,665975,456438,340478,869380,988771,246761,905458,488006,713738,964571,368946,866248,344754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]