SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457798 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457798 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190058,851886,460925,787683,756454,184061,688911,481792,526451,212386,687058,550035,930513,927797,185857,271388,500941,331228,210390,475440,1027648,381210,154438,834525,625445,659743,290420,857209,478055,282528,129760,167816,654684,258273,583726,6409,347225,161915,948612,1022560,997313,446744,993531,538242,34380,889156,438425,140742,109829,355027,636680,333672,410163,851296,365592,396297,942780,439011,727124,616928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]