SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38080 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38080 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486303,533751,140138,570653,1021139,302005,571333,114688,511555,9982,105901,709301,335185,964246,740131,551806,355458,324127,687150,283568,12068,633364,1003835,53493,129332,479504,627296,657176,8334,151396,629454,412639,224178,892339,131507,434592,1016712,138123,908511,299437,640512,557115,322573,382789,189345,613901,117258,520453,417975,846982,510575,1000576,344846,913100,896475,66345,962182,985369,282580,364899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]