SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292813 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292813 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488092,560459,88395,346794,636104,554462,791739,778664,366085,742902,897755,74096,805309,379210,353743,431318,939724,116917,827365,730254,838843,652514,454384,799322,937085,431827,310031,925209,425446,1045481,813027,159530,353263,128783,503754,139297,896342,43468,1035663,662730,171304,801498,129382,618934,457863,807294,254865,866655,516004,273002,933107,143503,834191,847029,683030,207527,837363,705297,710280,836940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]