SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005667s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644513 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644513 [ RunTime:0.006392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465963,474231,874585,692846,366,281074,37782,653411,901852,789109,864665,390016,377410,677490,952844,341311,64764,163764,104113,8174,152476,401143,687013,393388,970796,215142,464966,1043018,950740,221416,591079,635488,352723,265211,1018546,692266,162203,520917,98266,504887,1007075,977320,689286,946401,129049,285053,421071,757970,161444,765700,1019806,81280,747083,739928,654967,170742,975048,872387,1023470,96114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001572s ]