SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31573 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31573 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456580,20282,711494,366668,351081,507195,672594,546856,870153,620198,407809,1004068,715472,26267,912814,864779,959994,394277,183595,26532,613146,803627,325646,193964,432857,327819,880921,539039,558951,629550,170294,802103,59842,714107,1003841,373026,879540,247220,119339,41921,20314,938326,234910,155811,780776,235881,307110,609578,368563,943361,355765,990016,761296,922381,239891,976751,1017253,493988,926896,52562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]