SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476816 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476816 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263383,123038,921410,228683,776893,366670,20910,749158,319532,865321,945383,400101,74802,433473,154116,865105,439988,945674,831077,387600,524470,7939,285277,859029,897110,134363,642939,827702,620964,327936,241205,286273,353041,419948,572363,223342,935209,707940,444526,800384,596004,54140,518112,789571,616388,88308,432296,755705,747546,315613,1043,344993,790685,544718,260449,389030,130872,189622,788897,559453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000729s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]