SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312112 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312112 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586809,825840,477027,1022179,518804,198948,230143,617720,894038,574678,73852,305229,571992,338270,97041,626257,280052,996427,758922,560011,1018961,460902,1038157,760049,584803,905341,640860,565556,69583,388088,624111,46399,140186,395421,134523,394304,508419,886304,376154,199081,949133,770472,952445,254526,558879,416391,662131,485973,560792,289093,23529,215929,318103,477071,429535,1812,193964,223555,338799,630358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]