SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299601 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299601 [ RunTime:0.003410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667603,465164,619815,1001134,78494,274176,999618,1010534,984764,428885,508110,68759,269476,401933,495039,927103,390144,111710,300740,616100,620016,461330,801319,1043856,65843,743967,842502,804297,711178,216980,763634,74723,496672,481656,6937,884663,696210,716067,316591,801058,344660,1043941,843071,566498,430998,401085,142278,429799,334090,914225,906122,229773,58905,36562,376759,459034,10319,5755,743656,887875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001360s ]