SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198033 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198033 [ RunTime:0.001430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470475,850230,423699,35330,78639,149809,841040,748288,722560,989900,1025718,789840,528569,750789,109595,267928,418283,757338,370123,516750,24325,1005472,266862,818368,394496,706937,575820,32263,871439,809131,273700,642957,459200,62553,432948,117542,552740,811280,385704,722739,1020055,253102,1004291,605148,1032468,895130,649653,92641,497154,475473,34456,113004,593226,638027,706859,36547,602994,559566,1005579,106272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]