SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588913 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588913 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002544,487187,266101,501414,846754,196171,801335,991240,898397,345218,858780,457339,1030473,518405,298017,211405,910616,153878,487503,701249,249462,95564,35319,595256,513333,870470,836318,487874,329459,215082,920161,689150,22727,1022076,929593,931116,452373,745467,190235,735876,105869,560866,270588,743145,414458,604895,875746,82354,903637,670783,146831,733574,437810,652081,202094,4488,443139,782950,269216,477381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]