SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385043 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385043 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541545,704164,102412,919853,223522,735808,304782,680419,43186,3084,819010,1024300,936036,739052,244774,898024,99506,847788,756380,7064,996663,662496,579172,718769,520988,401431,571894,382395,552236,308174,469717,662386,536500,254926,90699,915427,326560,185444,242108,986699,582567,555930,1016257,887890,454088,264870,1034429,392551,488849,779042,616753,649797,408314,622000,523763,475056,958988,373456,269815,537272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]