SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 640528 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 640528 [ RunTime:0.002850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612648,487888,485697,877047,208472,320668,395917,838174,267499,1011820,747517,309186,352128,337977,490417,836767,978609,920937,501676,991212,707274,169786,566710,129565,526881,33554,731487,190668,1003287,754588,170098,954319,217918,846796,564807,551284,549181,554924,38841,842390,200541,37627,209618,601619,765452,472491,882908,831059,923074,1000818,227075,264016,903581,688801,257797,919719,192156,339541,493699,678777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 640528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 640528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]