SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001072 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001072 [ RunTime:0.003346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532004,139946,977783,1005897,232815,779640,937935,983611,987283,313892,708448,156545,486530,866420,202004,565261,637322,814333,912547,513667,488754,803745,571665,889482,353159,224690,45328,767110,443792,531460,281523,1006209,75983,161026,68498,81642,797225,304552,67787,751305,919381,799910,226683,769251,793168,33391,849735,702474,202359,751939,680598,987586,263433,266940,577093,432452,412848,886002,61890,963743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]