SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415551 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415551 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (999816,753207,812741,608542,97376,888636,134817,207159,59751,866058,358504,206618,924744,244623,366528,353463,180248,474088,246755,247897,280658,961026,246094,171639,569813,178065,458174,732273,202757,438884,708921,1029196,740737,426655,322169,696723,221958,343849,447248,497275,951114,330083,789645,634393,666274,1024088,447967,508013,109371,234116,647169,438598,684465,663338,546958,945381,986610,365407,935564,678599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]