SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037447 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037447 [ RunTime:0.003073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723014,1034694,488664,747297,796423,868967,755440,174113,941561,188526,274005,288691,420,695392,161734,461069,595827,557334,205023,980806,1048128,319859,32789,271905,609312,423628,797567,912016,125216,99988,88676,190867,616790,333461,631662,673224,715522,330723,96532,818607,41400,677147,637896,333094,667087,637338,425165,368963,571145,838845,533645,534609,85985,447699,335719,925305,439829,887999,555576,674620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002907s ]