SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444389 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444389 [ RunTime:0.002935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718192,322221,443048,693160,607519,210807,616300,275516,212180,894142,879963,983908,482907,577785,940496,877396,373712,282591,890745,332980,627989,783722,434943,918580,372045,437437,653119,832134,416218,856447,993441,450112,988870,670332,299574,200219,74605,784253,650584,858520,37054,167206,248312,359802,395039,1005820,716720,305969,352890,817982,401676,861129,295874,301823,131319,713280,214290,943473,895458,224251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]