SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542099 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542099 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566545,607964,341462,547584,1032448,363403,434037,704606,542377,170567,861289,482858,441690,309617,579866,964559,392204,392249,761491,174637,767128,941726,77355,220686,48163,865958,703951,684216,13025,726785,862202,123690,883222,106920,829789,799684,225983,273841,168310,609695,101292,223223,969805,667300,860943,511107,662938,698957,764547,982392,483204,580066,341340,387999,724490,206503,159182,135562,498467,538082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]