SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465023 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465023 [ RunTime:0.005431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308916,904450,546737,775998,231126,778865,457645,398464,698398,875626,270357,1042552,814545,389615,818309,307584,18386,786689,286861,166088,177730,665236,636113,147318,252839,628007,327704,453728,872685,516096,385565,555829,65856,122883,291861,958563,538280,717615,665771,338103,948171,254520,772614,804527,452681,445023,932086,159244,754085,288677,42020,828727,251140,1048521,304274,13852,179081,859974,488636,767341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]