SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39230 LIMIT 1 [ RunTime:0.001128s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39230 [ RunTime:0.003069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245387,511982,941879,945543,675119,857939,377470,220452,180618,233781,347418,129891,840508,672763,889249,404698,624122,96489,30163,696218,441905,533480,282869,662016,852275,24679,439812,982808,447241,452277,797255,415537,138344,749325,704517,955107,52079,218363,484672,1018560,128096,735468,106301,54886,968464,223375,716391,247066,155701,1004094,367967,482416,63281,923176,458229,65184,770649,588735,822440,983465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000940s ]