SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200483 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200483 [ RunTime:0.002520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257661,589870,947224,75227,862072,591164,841493,900768,243174,165795,935887,793515,634778,632196,512230,867094,942829,151817,748565,304059,42529,742106,797001,772709,216058,567844,474938,739284,894860,891687,181262,589599,737198,981186,143321,392393,991284,57418,999202,704480,616315,973720,887477,881380,971717,934999,161051,926356,914384,169733,341586,502134,53656,786581,318212,444872,369217,923984,403949,289687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]