SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 916921 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 916921 [ RunTime:0.002989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338800,550192,382156,43175,836883,386489,472954,254800,738476,886753,404934,754145,94469,652348,407113,650369,375565,25268,1021108,256908,723149,400238,1016005,710766,691465,471721,125645,770717,797871,830190,226999,350822,734347,228528,334602,220037,190579,224756,313456,154357,278191,162284,819080,872031,39412,889625,1007245,995862,635528,793375,356948,264076,771143,774267,955985,344926,103744,779132,330666,708669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 916921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 916921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]