SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200524 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200524 [ RunTime:0.004926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603035,2207,447813,56192,364449,721430,234864,1028308,155073,846312,765846,983744,186818,89236,545918,901556,944775,152914,118354,186088,453086,977679,331706,129363,305803,71359,40227,615282,40851,28524,214700,189813,683515,592531,431701,920567,183011,486789,149793,692709,618892,654991,588807,1011626,566075,950667,295989,49863,586314,260785,509816,77658,950529,344004,228996,427485,459081,977398,674038,604013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000782s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]