SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535215 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535215 [ RunTime:0.002051s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873932,844374,110734,90744,584665,236494,452826,653936,753774,594526,185699,146112,11137,663811,652853,249992,404536,878931,150123,681771,199844,430321,165519,377370,691922,452290,463615,177977,912291,466481,175230,544194,859590,786390,817815,430601,1018580,315986,28097,166311,268442,586344,253427,912317,895415,998419,208632,766503,825763,108337,428524,433754,389055,896933,842490,961502,600834,860169,437552,538731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]