SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001909s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584109 LIMIT 1 [ RunTime:0.001698s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584109 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413251,1028784,888940,164737,548696,432715,1021643,415157,1009336,790399,85911,685144,223486,440862,526500,625119,267543,946946,877491,942620,1026715,570939,762612,587791,943464,680878,1041055,889167,1034468,181237,362342,469442,536625,144796,980131,422564,1028890,420366,165227,454405,58908,779483,1006035,598344,661376,609565,236149,51200,301422,162348,750891,270306,245308,591233,249703,18243,107817,919977,279059,470572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]