SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480518 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480518 [ RunTime:0.004458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611169,562849,753764,1024540,612619,628592,983328,235314,650207,140698,581364,840965,612684,300443,533502,160371,976419,892774,450817,720016,619683,69614,707131,942765,103662,221217,473518,908361,45602,926116,36315,1014236,722761,883309,310684,969145,709984,488692,227561,699639,685723,630626,29238,356636,141894,957789,477320,856181,163932,989049,1008300,14242,535180,597049,801783,926204,380618,748464,541980,994775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002854s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002588s ]