SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001751s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292901 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292901 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924031,282534,428325,478122,222052,739357,27243,917162,57466,46589,564325,930218,123610,921175,830371,271329,162900,137914,583841,993878,521673,537757,421946,342657,398156,274250,516701,655888,420441,1005312,660203,884529,765119,730165,671363,945103,565244,969890,585703,361927,349711,941760,477140,52816,275380,599414,989726,703384,448900,905538,832090,319542,745931,586899,111893,967506,86619,326420,766636,777941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]