SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567518 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567518 [ RunTime:0.003129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316033,672603,748937,598368,1014559,622573,173598,733445,1033902,552336,851979,595985,312982,495259,543991,808692,67518,408897,883382,251946,688509,221348,191854,132326,738952,236463,604729,566530,201870,721445,783576,1031332,58052,294539,742080,827202,941686,575096,191183,870408,465095,579804,788658,571108,173160,604496,39257,486468,943447,66437,682479,418566,9806,2317,895535,745539,1018950,36117,226679,85550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]