SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501097 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501097 [ RunTime:0.003196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289777,52751,384998,452405,763739,770469,150378,944832,391892,838109,596213,692047,183940,21928,496377,483929,481688,240736,78602,697977,167732,1040535,379115,242262,877306,878692,423968,155210,271033,854243,641535,183515,850245,632239,614430,410571,242513,253327,702810,317924,978590,582464,686392,263354,278904,997471,690297,956507,493636,94237,619192,351343,1005445,949072,520614,410849,348090,873093,629426,1047301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]