SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475911 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475911 [ RunTime:0.003189s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771613,589893,691702,809110,474752,485347,9148,102587,542155,656796,468995,665796,694069,1016819,379445,210644,66369,751001,78496,348713,767037,410159,159795,686176,399515,1044692,355996,782661,670407,208860,510283,792894,880002,593008,129947,244503,415081,555157,195914,772022,960808,327732,410327,296242,447522,880800,754403,364034,355030,231662,261503,45055,525515,572478,983057,607207,186222,709408,164653,7792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]