SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521986 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521986 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253467,490788,457554,608547,205476,1011575,864350,138649,188103,330697,1047240,170435,214558,299124,1003318,403161,919826,433154,528890,161275,97524,833482,371302,486479,812887,861708,303709,514193,577009,587825,344552,788530,59704,870530,666097,470790,731341,979246,390137,210228,884701,353334,300916,413308,923963,902913,773259,801235,285763,682760,873349,763792,664271,751178,185815,1020481,776237,437890,42170,617401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000391s ]