SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403816 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403816 [ RunTime:0.002826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628433,776893,202047,719884,1013873,199304,989279,60550,813227,984608,98372,516452,1008588,103491,316269,270380,132541,591364,338317,1036746,278605,958958,155628,724805,349850,482412,182395,53261,510831,257341,32495,304784,760,284292,668937,769071,342030,204795,345890,956747,54295,597915,765778,552985,656036,816398,216623,421836,345518,8920,470099,903758,956760,73220,729100,944133,534840,279146,96874,890001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]