SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020143 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020143 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248268,204098,839453,168396,958126,603745,468155,872784,776427,605455,952396,732342,866149,701973,144731,805665,338235,947275,331447,714216,33999,571800,194683,48055,1039257,474711,355363,719707,222819,28151,229015,227014,748626,581514,868202,550239,958771,24126,92157,1006106,60201,368389,323584,60279,1041131,304446,1004941,314985,781764,58,890875,549147,2403,372227,201580,660916,891000,766751,981004,601609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]