SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199848 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199848 [ RunTime:0.001322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935254,391907,469974,888822,826011,1047829,732069,224891,326390,33116,921711,169011,735520,198392,865381,993002,160647,396095,307546,594012,366201,257760,106001,405529,125332,67348,105110,522448,523070,644398,963057,457788,643702,211007,352285,703920,280613,111116,420953,8127,454184,1013447,815396,320625,302547,1038117,332794,377848,346461,958260,544895,416299,146082,38901,878825,477834,253206,853681,507339,455203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000741s ]