SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311018 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311018 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91018,964892,478552,360290,520198,605456,349664,294708,423284,48951,434731,572116,722324,775330,648179,991237,1018572,649978,258608,428712,644870,822040,1019799,913030,594301,465916,729296,712492,96060,844878,232725,58334,257131,609242,1044351,851948,724557,573132,332992,297705,432263,743060,881201,969965,666785,1042856,869385,903857,149194,892525,196526,774845,964082,65938,266802,311969,366670,984392,210013,256927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]