SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475722 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475722 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112016,751579,875195,625475,60480,350384,219800,394134,962765,517195,619317,708183,283781,541433,827314,757010,1029708,893221,643349,94556,144515,143550,368058,11315,492547,1044677,871157,666488,589293,26174,680534,595664,720049,307375,567939,380220,188641,575984,441860,814470,304090,208536,377878,705676,419863,218008,842585,339518,958548,80268,588194,701299,161940,180659,453345,386463,37605,470540,476100,765180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]