SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400008 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400008 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14488,898073,97668,838593,319014,631433,728371,698945,498270,1003005,1002355,436779,110717,980051,904887,1009417,499057,684132,983766,538512,30788,962271,1025354,111419,358033,1046992,835798,552067,879106,908772,127063,659403,827550,507857,65069,687906,462542,6373,950489,1028707,49888,212248,711877,378003,816277,769474,930608,899600,522412,372792,1019145,564593,23026,420400,879233,1020309,260849,310097,888749,984755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]