SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520971 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520971 [ RunTime:0.002544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459422,710680,24774,800569,301784,423789,107185,189060,891438,863880,350874,437593,814379,109513,82511,707778,617956,988066,622031,884467,709546,431648,666044,538484,930275,997275,384030,319388,725116,407240,638609,653307,765041,116790,949434,24592,417599,658082,904822,262883,856677,385442,747273,636179,17131,483222,70243,477717,291355,854145,67600,533900,444194,904652,170459,972431,935652,523730,413565,886210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]