SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105908 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105908 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172609,102668,980497,35826,1010071,925339,683649,152800,678367,217664,790722,906138,279844,1042736,686599,410322,549598,212433,296346,871211,700030,339438,984658,75577,52897,102472,953152,55186,700432,701427,1000412,728593,217051,992082,92197,253048,750883,643656,337576,605993,1015136,729456,184981,22160,384876,147857,970969,289631,717478,445013,500758,299074,450530,302336,599917,42861,586720,822153,620462,126947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]