SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407739 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407739 [ RunTime:0.002031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693907,601304,110353,859366,1017256,437943,251511,736199,1002080,206297,377951,291299,14026,108811,475189,83992,333059,420201,55936,163800,241487,475985,425620,547158,129805,198202,544265,663067,708538,51219,523795,390111,592467,991359,724579,536451,982006,481203,694753,57610,786444,515765,569302,329649,344040,979643,809754,54631,1004626,925193,584948,138722,496442,996016,442688,260325,590964,138467,696106,970048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]