SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300698 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300698 [ RunTime:0.002828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509202,694807,424613,169331,404161,537380,551879,127687,656272,756120,788340,757463,6809,1041477,481586,988055,672654,661011,398098,591183,1013748,770854,567550,953829,126335,122889,149649,766486,80162,300972,838304,666478,767843,989246,358625,523915,403353,37534,139931,824517,297040,423980,547148,36061,627179,691125,39595,226593,621613,763334,1026757,555437,18004,230283,736843,66538,722111,82734,241366,535434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000838s ]